﻿CREATE TABLE [dbo].[FactCLM_835]
(
[Receive_LocalTime] [datetime] NULL,
[CLM_835_ID_Key] [int] NULL,
[ProviderSummary_TS309_TotalActualPaymentAmount] [float] NULL,
[ProviderSummary_TS306_TotalCoveredChargeAmount] [float] NULL,
[ProviderSummary_TS307_TotalNonCoveredChargeAmount] [float] NULL,
[ProviderSummary_TS308_TotalDeniedChargeAmount] [float] NULL,
[ProviderSummary_TS305_TotalClaimChargeAmount] [float] NULL,
[ClaimPayment_CLP03_TotalClaimChargeAmount] [float] NULL,
[ClaimPayment_CLP05_PatientResponsibilityAmount] [float] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[EDIEnvelopeID_Key] [int] NULL,
[DateIDKey] [int] NULL,
[GenMsgInfoID_Key] [int] NULL,
[ClaimPayment_CLP04_ClaimPaymentAmount] [float] NULL,
[TimeID_key] [int] NULL,
[InsertDate] [datetime] NULL
) ON [PRIMARY]


